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
What are the limitations of joiner transformation?
how to load dimension table and fact table. plz tell me the steps.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
how tokens will generate?
Reusable transformation and shortcut differences
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Write the advantages of partitioning a session?
How can we remove the duplicates from flat file source?
What is informatica etl tool?
Explain how many types of dimensions are available in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
What is an expression transformation?
Can you use flat files in Mapplets.
What are the steps involved in the migration from older version to newer version of Informatica Server?