Interested to Buy Any Domain ? << Click Here >> for more details...
How your source files are coming to your ETL server.
Actually at which stage of your mapping it is happen.
- 1 Answers
- 7172 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / srini
Flat Filies are coming through Connect Direct in ETL Server.
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
how much memory (size) occupied by a session at runtime
can you avoid static cache in the lookup transformation? I mean can you
Under which circumstances, informatica server creates reject files?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Why we need XMLs?
how to join two flat files in informatica?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
How we can confirm all mappings in the repository simultaneously?
how many types of dimensions are available in informatica?
Teradata 
