Answer / sehaj

EVENTS ARE THE WAIT WHICH V IMPLEMENT ON OTHER TASKS ON WF BEFORE THE SPECIFIED REQUIREMENT IS FULLFILLES.
THESE ARE OF TWO TYPES
1.PREDEFINED(ALSO CALLED FILE WATCHER EVENT)
2.USER DEFINED

IN PREDEFINED WE CAN CHECK FOR A FILE TO BE PRESENT IN A PATH WE SPECIFY BEFOE V PROCEED WITH THE WF.

IN USER DEFINED WE CAN MAKE ANY TASK TO WAIT BEFORE A SPECIFIED TASK IN COMPLETE.
IN USER DEFINED EVENT WAIT N EVENT RAISE TASK ARE USED IN COMBINATION.

SEHAJ

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

---

r u done any partitions in ur project?

0 Answers   TCS,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

whatis the default data driven operation in informatica

2 Answers  

---

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.

0 Answers  

---

where is the reject loader .

1 Answers  

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

How can you complete unrcoverable sessions?

1 Answers  

---