What are your source in project and how you import in
informatica? How can i explain abt this?
Answer / jvdwhinfo
Hi All,
Sources in Informatica can differ from Client to Client and
project to project.
But mostly client will send sample data through flat files.
And the metadata of the sample data is imported from Source
analyzer by clicking on the option import from file.
I hope i gave the relevant answer.
If am wrong please let me know.
Thanks.
James.
Is This Answer Correct ? | 16 Yes | 0 No |
How big was your fact table
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
what is the diff b/w union and joiner and lookup?
How do we call shell scripts from informatica?
What does update strategy mean, and what are the different option of it?
Can I create one wrkflw which will run different wrkflws on schedule time?
Could you explain what is enterprise data warehouse?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Explain the different dimensions.
What is synonym?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
What are batches?