Interested to Buy Any Domain ? << Click Here >> for more details...
my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?
- 10 Answers
- 18581 Views
- Cap Gemini, Wipro, I also Faced
- E-Mail Answers
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 |
Under which circumstances, informatica server creates reject files?
What are the new features in Informatica 5.0?
If we have lookup table in workflow how do you trouble shhot to increase performance?
To provide support for Mainframes source data,which files r used as a COBOL files
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How to partition the Session?
What are the types of lookup?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What is update override?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Teradata 
