my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
Answers were Sorted based on User's Feedback
Answer / rajesh
Take the source into expression and map it to instances of
target.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / naga
Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target
Is This Answer Correct ? | 13 Yes | 4 No |
Answer / vidyasagar
just use the below query in SQ override:)
select * from table
union all
select * from table
Regards:
Vidyasagar
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / ram
sq---router(2 conditions which should be satisfied)---and passed to target.
will do the work
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sujana
use union transformation..connect source to multiple grps of union transformation..
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abhishek
Through normalizer it is possible just give all feild's
occurance as 2 time and link it from source. It will work.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jay
Very Simple method
QRC-----> TRGT
|
----> TRGT
Have two instance of target and
connect source to both target instances.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / subhransu panda
Through session partition we can achieve this.
Create 2 parallel pipeline and don't override the partitions in mapping properties.
Is This Answer Correct ? | 0 Yes | 0 No |
After SQ use Java transformation
SQ--Java transformation
for(int i=0;i<2;i++)
{
output_port=input_port;
generateRow();
}
Is This Answer Correct ? | 0 Yes | 0 No |
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
what is polling?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What the difference is between a database, a data warehouse and a data mart?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
What is informatica worklet?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar