Answer / davankumar

Actually from client we get only HLD(high level design)
document only.Besed on HLD WE have to create LLD(low level
design),STT (source to tarhet),TEST CASES,UT(unit test
case).

Answer / anukalliappan

We get FSD(Functional specification Document) from client. We have to create HLD,LLD,Mapping spec,RTM(Req Tracabilty Matrix),Test caces and Unit test report.

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---