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 |
can we have to do changes in session property when we are dynamically generating target files?
difference between repository database and repository service?
Partition, what happens if the specified key range is shorter and longer
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Which kind of index is preferred in DWH?
Can we insert ,update ,delete in target tables with one update strategy tran.?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
How to extract original records at one target & Duplicate records at one target?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
what is confirmed dimension?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
what is the significance of newlookup port in dynamic look up