Interested to Buy Any Domain ? << Click Here >> for more details...
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
- 2 Answers
- 7307 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dilip ingole
BY USING SQL
WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / triveni
source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))
| Is This Answer Correct ? | 1 Yes | 3 No |
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
how to duplicates from expression transformation without using sorter before that
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
difference between shortcut and reusable transformation?
Differentiate between source qualifier and filter transformation?
star and snowflake schema?
What is a test load?
Do you have knowledge in ralph kimball methodology
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
What is data transformation manager process?
What are the associated ports in look up T/R.
How can you complete unrcoverable sessions?
Teradata 
