I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col.
- 5 Answers
- 13444 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / dl
no rows from the source qualifier transformation.It gives
an error like" query should return exactly 10 fields to
match fields projected from the source qualifier." .
Because number of rows selected in sql override must eqal
to number of rows connected to the next transformation from
source qulifier.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
What is fact table? Explain the different kinds of facts.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Differentiate between a database and data warehouse?
What are the popular informatica products?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is meant by target load plan?
Explain Dataware house architecture .how data flow from intial to end?
What are active transformations.
What is Cognos script editor?
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
How to partition the Session?
What can we do to improve the performance of informatica aggregator transformation?
