How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nagaraj
hi, kalyan
can u write that query in sql override.
Is This Answer Correct ? | 0 Yes | 3 No |
what is degenerated dimension?
why do u use shortcuts in informatica.?
What are the different clients of powercenter?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
in performance wise union is past,union all is past
Explain the difference between a data warehouse and a data mart?
What is incremental aggregation?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
What is the difference between a repository server and a powerhouse?
What are the tasks that source qualifier performs?