Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of Sequence Generator T/R?
- 3 Answers
- 16520 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mallikarjun
While migrating the code we will get a dialouge box in that there are two
values retain and replace but i don't think about reset.
if you are deploying into production environment, you may want to retain the
current values for sequence Generator transformation in the target folder
instead of replacing them.
To retain values, check the box
uncheck for the replace.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / jz
During Migrating into Production need to reset the value in
the Seq gen t/r.
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / akhil4
using sequence generator t/r, u can not create sequence with alphabets
| Is This Answer Correct ? | 8 Yes | 7 No |
what are objects in data warehouse?
What is lookup transformation?
What is Micro Strategy? Why is it used for?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What is critical mapping?
What is the difference between Power Centre and Power Mart?
What is update override?
what is INFORMATICA TESTING process
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.
Where can we find the throughput option in informatica?
Teradata 
