Interested to Buy Any Domain ? << Click Here >> for more details...
what is correlated query?
- 2 Answers
- 5831 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti
in correlated query is nothing but a sub query, but the difference is sub query can executes first, based on the result the main query executes...
| Is This Answer Correct ? | 2 Yes | 1 No |
What are data-driven sessions?
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)
How many number of sessions can one group in batches?
How many transformations can be used in mapplets.
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
How to convert multiple rows to single row (multiple columns) in informatica
what is SDLC way of code development?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
What is the difference between Bulk Load and Normal Load
how many types transformations supported by sortedinput?
In how many ways we can create ports?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Teradata 
