Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8794 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / sudheer
As u r using source as flat file so u can go for partitioning preferably Single-Thread or Multi-Thread partitioning.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of target designer?
What is an unconnected transformation?
Explain the difference between mapping parameter and mapping variable?
Explain sessions. Explain how batches are used to combine executions?
Is it possible to use a client with different version than that of its Informatica server?
How to partition the Session?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to extract sap data using informatica?
Which transformation is needed while using the Cobol sources as source definitions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
During the running session, output files are created by informatica server. Enlist few of them.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you handle two sessions in Informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
