Interested to Buy Any Domain ? << Click Here >> for more details...
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
- 1 Answers
- 2430 Views
- I also Faced
- E-Mail Answers
Answer / isha
Among these three, you can only use seq generator (only reusable sequence generator)
| Is This Answer Correct ? | 0 Yes | 0 No |
TELL ME ABOUT WORK FLOW SCHEDULING?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What you know about transaction control transformation?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
Mention few advantages of router transformation over filter transformation.
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
difference between repository database and repository service?
expain about the tune parameters?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Can you start a session inside a batch individually?
Teradata 
