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
- 4575 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
server hot-ws270 is connect to Repository B. What does it mean?
COM components can be used in Informatica
Explain why we use partitioning the session in informatica?
Why union transformation is an active transformation?
What is the session task and command task?
What is update strategy transform?
How can we remove the duplicates from flat file source?
What does command task mean?
What is joiner transformation in informatica?
How to extract the informatica rejected data?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can you use flat files in Mapplets.
What is a joiner transformation and why it is an active one?
Describe an informatica powercenter?
What is a node in Informatica?
