Session 3: Informatica File to Table load | informatica flat file to table |Informatica tutorial

[@NICITACADEMY]

Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?

You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks

[@NICITACADEMY]

Hi Guys, what else do you want to learn from me?

Add Comment down below and let me know so I can create more such tutorials for you!
📌 Got a question on the topic? Please share it in the comment section below and I will answer it for you.
📌 If you are looking for Live training session, Please write to [e-mail] or whatsapp [phone]
📌 Join Whatsapp chat for any Informatica help or interview discussion chat.whatsapp.com/CmFk9EO4eVTKKa3eyXn3mh
🔥NiC IT Academy Informatica Training:
📌 Do subscribe to NiC IT Academy channel & get regular updates on videos
📕Learn complete informatica tutorial here:
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
Thanks

[@harikrishnan6208]

Once again watching the entire , Thanks a lot for the effort

[@NICITACADEMY]

Always welcome

[@SuperSudeshna]

Great sir . Thank u 🙏🏻
I have a flat file on unix server . How can i create a mapping to read that file sitting on unix server ? Please help sir

[@SuperSudeshna]

Do i need to go to source designer and then create a flat file just like its in Unix ?? Or should i import from flatfiles ?

[@shereenfarha223]

Thank you so much sir.... May Allah bless you ..😊

[@NICITACADEMY]

Most welcome

[@erigelavani4162]

Thanks sir for your videos

[@NICITACADEMY]

Most welcome

[@ChiralaBalaji]

How to load the data in oracle please tell me ?

[@Lakshmi_shivanaS]

Can you please share link here where i can download all notebook files and doc in which ur explaining

[@rajeshs8846]

@NIT IT ACADEMY I am often getting the error :[PCSF-46007]No gateway connectivity is provided for domain[Domain] while connecting to the repository. I was able to do the installation properly and able to do the simple pass thru mapping as well. But this error occurs frequently. Could you kindly suggest what can be done?

[@aishwaryalakshmikumar2661]

Row [1], field [HIRE_DATE]: Invalid date: [02-05-2006 00:00]. The row will be skipped. i recieve this error while loading flat file to table and in indirect file loading also. how to rectify it?

[@bhupathikrishna3083]

Hai sir I am Bhupathi I have a doubt sir, if one to one mapping in flat file to table is Target but in session log Target connection is source is possible .

[@NICITACADEMY]

it will fail if the table is not there, it will succeeded if the target table is available in source connection

[@bhupathikrishna3083]

@@NICITACADEMY
thank you so much sir

[@javedabdool1187]

after creating the flat file, how can i afterwards check where its path is?

[@NICITACADEMY]

you will be providing FF path right? you need to check there.

[@qlqa8932]

What is Merge Type in Target Properties for Flat File?
1)No Merge, 2)Sequential Merge, 3)File List, 4)Concurrent Merge

[@TheMelody225]

Hi, I tried to load from flat file to flat file but it has loaded just header and remaining rows are empty.

[@anilkumarakc1046]

super explanation

[@NICITACADEMY]

Thank you so much 🙂

[@anilkumarakc1046]

@@NICITACADEMY your teaching helpfull to realtime

[@subhanivasareddythummapudi3836]

How do you do UNIT Testing for a Flat File..?

[@subhanivasareddythummapudi3836]

@NIC IT ACADEMY , Chandra could you tell the answer for my query on your video.

[@NICITACADEMY]

please check my ETL testing video, I have explained already.
ua-cam.com/video/ZYa9aaFAOi8/v-deo.html

[@paddu28]

Hi sir, please share video on data warehousing

[@NICITACADEMY]

Please check the playlist and Business Intelligence video. Day 1 session.

[@paddu28]

Thank you sir

[@mukkalavanya6013]

when i am selecting mapping from the list, it is not appearing.. what is the can anyone tell me??

[@NICITACADEMY]

Please open the respective folder.

[@vijaykumawat7911]

Great

[@NICITACADEMY]

Thanks

[@sushmakudipudi2684]

If a new column is added in flat file source, how to refresh it

[@NICITACADEMY]

You have to manually add the same column in Informatica level from source to target. It will not refresh automatically.

[@sushmakudipudi2684]

@@NICITACADEMY I added and I'm getting metadata for the columns is not matching error

[@NICITACADEMY]

The column names in source analyzer +SQ and File should be same. Please check.

[@srinuvasan2050]

Great 👏👏👏

[@NICITACADEMY]

Thanks

[@meetmrbrucekadin-dogoargen2655]

Can we have a column in flat files for timestamp

[@NICITACADEMY]

yes, please use expression transformation to create timestamp.

[@ritabratachakraborty7776]

The workflow succeeded but the rows did not loaded in the target. It is showing 107 rows rejected.

[@NICITACADEMY]

please share error messages.

[@ritabratachakraborty7776]

@@NICITACADEMY ,i am getting an error as FR_3067 Row [1], field [HIREDATE]: Invalid date: [17-06-01]. The row will be skipped

[@abybhattacharya8782]

Need to change Date format to dd-mm-yy instead of dd-mon-yy

[@ishaansalwan4017]

@@abybhattacharya8782 thanks man

[@AAbhi-d5k]

I'm also getting same issue but not having any errors in workflow monitor pls help me

[@jayakrishnavenikapa6097]

All the data is rejected 107 rows employees table

[@NICITACADEMY]

Please check the session what is the error?, meanwhile check the data types of each column.

[@AAbhi-d5k]

I'm also getting same issue

[@ShubhamPatil-cu1qo]

JAY HIND

[@Rishi_Maddineni]

bro session 1, 2 link please

[@NICITACADEMY]

I will upload soon. Keep watching.