In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 18772 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / n.prasad
we can use In operator in source qualifier and sql
transformation if the source tables belongs oracle.otherwise
we cannot use in operator in informatica transformation.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
where to store informatica rejected data?
what is unit testing?tell me proceedure
I have a flat file, want to reverse the contents of the flat file
What is the surrogate key?
pmscmd startworkflow -sv
What are the different ways to implement parallel processing in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is session task and command task?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Explain sessions. Explain how batches are used to combine executions?
How can we remove the duplicates from flat file source?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain the mapping variable usage example in informatica
