if soource is having 10 records how will u insert 20
records to target
Answers were Sorted based on User's Feedback
Answer / sreekanth
select * from table_name
union all
select * from table_name;
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / priyank
Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).
SQ1 --> UNION --> EXP --> Target
SQ2
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saravana
we can user Normalizer transformation, to convert a row into double row and then load it into target
| Is This Answer Correct ? | 0 Yes | 0 No |
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
I have source like this 1:2;3. so i want to load the target as 123
where is the reject loader .
What are session parameters ? How do you set them?
how to get the only updated records in the target
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is junk dimension
Why we use stored procedure transformation?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
In which circumstances that informatica server creates Reject files?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?