Answer / niranjana

Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships

Answer / manju

Sources, Targets, Mappings, Mapplets, sessions, workflows,
worklets, tables, views, sequences,procedures, cursors... are
objects part of data warehouse.

How do you migrate data from one environment to another?

0 Answers  

---

How i can upload the MainFrame source For Informatica ?

1 Answers  

---

When to use normalization transformation other than cobol source?

2 Answers  

---

How to generate sequence numbers?

0 Answers  

---

How to elaborate tracing level?

0 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

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,

---

How many ways you create ports?

1 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

can you use flat file for repository?why?

2 Answers   TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---