Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
- 2 Answers
- 13394 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / viresh
Usually in RTR we create various groups we certain conditions.
If u have two target then use two filters and put the filter
condition.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / amit
RTX having two groups user defined and one default .
for user defined use filter from SQT and put negation of
all coditions with AND in default... ex.u have 2 grps dept
= 20 and default dept !=20
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
lookup transformation with screenshots
What happens when a session fails and you click on recover?
why we use datawarehouse
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how i will stop my workflow after 10 errors
How can we store previous session logs?
What is hash partition?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
in which situations do u go for starflake schema ?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Teradata 
