Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46530 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / su
The source qualifier converts user defined data types to
informatica data types.
The sorce qualifier is automatically generated only for the
flat files,for other sources we need to create it.
The basic transformation that is used in informatica is
source qualifier transformation.
We can write sql query in this transformation and we can
even override the existing sql query.
Using this transformation we can even perform
aggregator,filter,expression,sorting and join
transformations also.
It is used to join the homogenous source types.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain lookup transformation in informatica
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a predefined event?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the databases that informatica can connect to windows?
how we can load rejected record's at run time?(not through bad files)
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Did u used latest transformations of 8.6.0? for what?
Do you find any difficulty while working with flat files as source and target?
