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
- 4531 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
How to partition the Session?
What is informatica worklet?
What is meant by incremental aggregation?
What is data caches/ index caches?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How we can use union transformation?
what is unit testing?tell me proceedure
How to generate sequence numbers without using the sequence generator transformation?
Have you worked with/created Parameter file
explain one complex mapping with logic? sales project?
How does a rank transform differ from aggregator transform functions max and min?
Separate from a database, an information bazaar, and an information stockroom?
How to use procedural logic inside infromatica?
In informatics server which files are created during the session rums?
what is SDLC way of code development?
