in static and dynamic which one is better
- 2 Answers
- 5479 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 2 No |
How will you display "Mr" for male & "Mrs" for female in target table?
Can we call a stored procedure from a unix script which is run using command task
What is the benefit of session partitioning?
What are the connected or unconnected transforamations?
What is repository manager?
what is the size of u r source(like file or table)?
Can I create one wrkflw which will run different wrkflws on schedule time?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
In real time scenario where can we use mapping parameters and variables?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
Teradata 
