Howmany ways yoU can update a relational source defintion
and what are they?
- 1 Answers
- 5058 Views
- I also Faced
- E-Mail Answers
Answer / swetha
Two ways
1. Edit the definition
2. Reimport the defintion
| Is This Answer Correct ? | 2 Yes | 0 No |
if we have a delimiters at unwanted places in a flat file how can we over come those.
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
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?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
How Union Transformation is an Active Trans?
What is meant by lookup transformation?
in which situations do u go for sequence generator ?
tell me about your project functionality
What is limitations of truncate and load option
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Teradata 
