Interested to Buy Any Domain ? << Click Here >> for more details...
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?
I am new to Informatica,can anybody suggest me the idea?
- 2 Answers
- 4680 Views
- I also Faced
- E-Mail Answers
Answer Posted / naveenkumar
drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is lookup transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to extract sap data using informatica?
What is primary and backup node?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How do you take back up of repository?
What are the components of workflow manager?
Explain the different lookup methods used in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to partition the Session?
What are the different ways to implement parallel processing in informatica?
Differentiate between reusable transformation and mapplet.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is pmcmd command?
How can we remove the duplicates from flat file source?
