Interested to Buy Any Domain ? << Click Here >> for more details...
After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
- 6 Answers
- 12862 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kanth
Here they are having Heterogeneous sources how can those
can be joined at source quaifier.i think the question is
not clear u cannot darg the three heterogeneous siurces to
sinle source qualifier
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / atiric software(raja)
we cannot join haterogeneous sources in the s.q so we
cannot map those ports to target directly if we want we must
use the joiner transformation
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / bidhar
You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / madhukar
We cant perform heterogeneous sources with sqt.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swetha
NO.Unless and until u join those three ports in source
qualifier you cannot map them directly.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / eric yang
To Swetha,
I am afraid these 3 ports have been joined already in source
qualifier, and therefore can map directly to a target, why not?
| Is This Answer Correct ? | 1 Yes | 2 No |
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What do you mean by blocking transformation?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
difference between stop and abort
Write the program through which the records can be updated?
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.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can you use flat file for repository?why?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Teradata 
