2,if we have 3 pipeline containing 3 targets and each target
is connected with diff sequence generator ,let us assume
first target is populated with seq no1-9,so what would be
the number generated by other two sequence generator?what is
the diff in o/p if when we use reusable sequence
generator?what would be the diff if we place expression in
between target and sequence generator?

Answer Posted / sree

Each sequence generator generates numbers depending on
their start value and incrementby value.

If you are using reusable sequence generator and expression
trans is in between target and reusble sequence generator,
then all targets will be populated with the same sequence
numbers.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

EXL informatica Questions

1128


What is exclusive and normal mode for repository services?

885


How will the document be delivered to me?

806


What are the transformations that are not supported in mapplet?

773


Make a note of the quantity vaults made in informatica?

757


How do you promote a non-reusable transformation to reusable transformation?

890


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6917


How would you copy the content of one repository to another repository?

757


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1905


Write the advantages of partitioning a session?

977


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?

745


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1846


What is meant by pre and post session shell command?

849


What are the new features of informatica 9.x developer?

731


How can you validate all mappings in the repository simultaneously?

1023