Interested to Buy Any Domain ? << Click Here >> for more details...
What is sql query override? When did u use sql query override?
- 1 Answers
- 7119 Views
- TCS, I also Faced
- E-Mail Answers
Answer / santhosh
sql override is used to write sql select statements
sql override contains in source qualifier transformation
we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database
| Is This Answer Correct ? | 6 Yes | 0 No |
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
Describe an informatica powercenter?
can a port in expression transf be given the name DISTINCT
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain sessions and how many types of sessions are there?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What is joiner transformation in informatica?
What are the phases in SDLC?
Performance wise which is better joiner or look up ? Give me with example?
Teradata 
