Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7170 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
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can we delete duplicate rows from flat files?
What is joiner transformation?
what is the hint? how to use it to reduce the query processing in program?
Describe an informatica powercenter?
how we can load rejected record's at run time?(not through bad files)
can you please explain me pre session and post session options?
What is informatica metadata and where is it stored?
have u done any performance tuning? how u ll do?
Describe data concatenation?
How do you promote a non-reusable transformation to reusable transformation?
Tell me about MD5 functions in informatica
What is a stored procedure transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Define sessions in informatica etl?
