Answer Posted / murali krishna
We can use Variable port in the following transformations.
1. Expression Transformation
2. Aggregated transformation
3. Rank Transformation
| Is This Answer Correct ? | 49 Yes | 3 No |
Post New Answer View All Answers
differences between service based and product based?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is rank transform?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
difference between informatica 8.1.1 and 8.6
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Under which circumstances, informatica server creates reject files?
What is exclusive and normal mode for repository services?
what is the -ve test case in your project.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what is size of u r database?
What the difference is between a database, a data warehouse and a data mart?
What is the sql query overwrite in source qualifier in informatica
Write the advantages of partitioning a session?
Enlist some properties of sessions.