How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Answer Posted / priyank

one varibale port.

Var_port=IIF(Var_port=0,1,Var_port+1)
Out_port=Var_port

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a node as a gateway node and the same node can be assigned to a grid?

641


what is diff b/t sorter t/r and agg have the option sorter property...

1748


What is the function of aggregator transformation?

582


How will the document be delivered to me?

620


Explain load alternative records / rows into multiple targets - informatica

689






How to convert multiple rows to single row (multiple columns) in informatica

899


what is the hint? how to use it to reduce the query processing in program?

6320


generate date / time dimension in informatica

721


Explain in detail scd type 2 through mapping.

619


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1779


What is pmcmd command?

677


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1466


What are the data movement modes in informatica?

704


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1700


What are the limitations of joiner transformation?

656