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
- 7435 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 |
How to load duplicate records in to a target table which has a primary key?
when will we go for unconnected lookup transformation in Informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
how did u understand business requirement?
I have source like this 1:2;3. so i want to load the target as 123
EXL informatica Questions
How we will implement Pushdown Optimization and Types in Informatica with better examples
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is materialized view?
What is the difference between lookup override and souce qualifier override ?
Under what condition selecting sorted input in aggregator may fail the session?
what is the logic will you implement to load data into a fact table from n dimension tables?
Teradata 
