Answer / babu

Hi,
As per my knowledge only the reson is the amount of the
source data is too high compare to previous data.

Answer / gyana

delay of session
-----------------------
(1) amount of source data may huge
(2) database connection may slow down,thats y data transfer is slow
(3) if ur using cache based t/r,dn there must be performance issue in cache part

SOLUTIONS
-----------
(1) CHECK THE \DATABASE CONNECTIONS AND NETWORK SPEED
(2) CHECK CACHE SIZE
(3) MINIMISE THE USE OF CACHE BASED T/R USE

IF I AM WRONG DN LET ME NOW..MY MAIL ID IS(gyana.informatica@gmail.com)

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

Differentiate between Load Manager and DTM?

0 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.

1 Answers  

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

Can you use flat files in Mapplets.

0 Answers  

---