we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.

Answer Posted / lokesh

src->sq->seq_gen->exp->flt->targer

in seq_gen property's put cycle 3,

write a condition as a nextlevel=2, insert into target.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define update strategy?

625


How is union transformation utilized?

558


What are session parameters ? How do you set them?

1363


What is standalone command task?

695


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1860






As union transformation gives UNION ALL output, how you will get the UNION output?

635


Whats there in global repository

1252


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1440


What is meant by lookup transformation? Explain the types of lookup transformation?

555


What is transformation?

650


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

594


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1740


While migrating the data from one environment to another environment how would you manage the connections?

613


How many transformations can be used in mapplets.

1443


What is repository manager?

526