Can we have a Mapping without a Source Qualifier?
Answers were Sorted based on User's Feedback
Answer / nagesh
No. Sourse Qualifier is a must for informatica mappings.
What the source qualifier does is, when we add a relational
or flat file source definition to a mapping, we need to
connect it to a Source Qualifier Transformation. The SQ
represents the rows that the Integration Service reads when
it runs in the session.Because we need to apply a business
logic in the staging area, the SQ allows us to access the
data and convert it into the informatica data types thro
respective transformations. Thus we will be able to apply
the business logic and transform the data to be compatible
with target database with the help of SQ.
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / santosh
NO.There is no question of mapping with out a source qualifier in informtica.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / dj
I think yes we take source based lookup.plz correct if i was wrong
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / schwab
Actually NO,
But we can do that with the use of Maplet and maplet should
have SQ
| Is This Answer Correct ? | 2 Yes | 8 No |
How will you convert rows into columns or columns into rows
How can you differentiate between powercenter and power map?
What could be the possible resons of locks by user?
In a sequential batch can u run the session if previous session fails?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
What is mapplet in informatica?
Explain the etl program with few examples.
what type of problem you faced insales project or insurance project
What are the different threads in DTM process?
what are objects in data warehouse?