Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
- 6 Answers
- 11399 Views
- I also Faced
- E-Mail Answers
Answer Posted / ojesh
First do a count of the records in the file using a wc -l unix command, store that number in a variable.
create a counter in an expression and increment it with every icoming record.
create a router after that and route if the counter is less than half to target 1 else target 2.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is data movement mode in Informatica and difference between them?
How do you promote a non-reusable transformation to reusable transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you update the records with or without using update strategy?
What is a filter transformation?
Implementation methodology
write a query to retrieve the latest records from the table sorted by version(scd)
Explain dynamic target flat file name generation in informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How many dimensions are there in informatica?
How to use pmcmd utility command?
Is there any way to read the ms excel datas directly into informatica?
Explain the shared cache and re-cache?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
