Interested to Buy Any Domain ? << Click Here >> for more details...
Why use shortcuts(Instead of making copies).
- 1 Answers
- 3514 Views
- I also Faced
- E-Mail Answers
Answer / meera
creating copies takes extra memory. it is anlaogus to have a complete duplicate of the mapping. whereas shortcut refers to the refrence for the mapping. when creating shortcut memory is not used up . and any change made to the original reference (mapping) will be reflected in the shortcut.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is incremental aggregation?
How can you join two tables without any common column present in them?
Explain the different kinds of facts.
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
What is factless fact schema?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the difference between Bitmap and Btree index?
Why is sorter an active transformation?
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.
which is better perfomancewise lookup or joiner and why?can anyone give example?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Teradata 
