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 |
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what are the settiings that u use to cofigure the joiner transformation?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Why update strategy and union transformations are active?
Differentiate between a database and data warehouse?
guys which is the best institute in banglore to learn informatica??
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
what is difference between dimention table and fact table?
What is the Difference between PowerPlay transformer and power play reports?
have u done any performance tuning? how u ll do?
What is difference between Mapplet and reusable transformation?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse