i have two sources two flatfiles same structure
one flatfile contain 100 million recs
another flatfile contain 10 million recs
i have to connect single target(performance oriented answer)
what are the steps we have to do this scenario
Answer Posted / tejaetl
i answered this question both the flatfiles connet to union
connect to single target
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How is union transformation utilized?
How to extract sap data using informatica?
What is the need of etl tools?
Can anyone tell me the new features in Informatica 9 Version?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain load alternative records / rows into multiple targets - informatica
What is the scenario which compels informatica server to reject files?
what is the -ve test case in your project.
Explain in detail scd type 2 through mapping.
Explain the use of aggregator cache file?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Describe an informatica powercenter?
Explain the different dimensions.