how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
- 2 Answers
- 6755 Views
- I also Faced
- E-Mail Answers
Answer Posted / triveni
source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
COM components can be used in Informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean by worklet?
What is a surrogate key?
How do you load alternate records into different tables through mapping flow?
How to join three sources using joiner? Explain though mapping flow.
What is workflow monitor?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain what is informatica metadata and where is it stored?
Define filter transformation?
