Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30544 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ram pothineni
Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row). Connect both to target. Dont forget to give reset
option in SEQ generator.
http://it.toolbox.com/people/raambabuchowdary/
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
During the running session, output files are created by informatica server. Enlist few of them.
What is union transformation?
What is informatica worklet?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How can informatica be used for an organization?
Different circumstance which drives informatica server to expel records?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Is there any way to read the ms excel datas directly into informatica?
How does a rank transform differ from aggregator transform functions max and min?
How can we update a record in the target table without using update strategy?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does “tail –f” command do and what is its use as an Informatica admin.
Explain Dataware house architecture .how data flow from intial to end?
If informatica has its scheduler why using third party scheduler?
