Answer / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

What is sorter transformation?

0 Answers  

---

What is Datadriven?

2 Answers   Informatica,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

What are Rapid changing dimensions?

1 Answers  

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

What is DTM process?

4 Answers  

---

What is aggregate awareness?

1 Answers  

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---