I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Answer Posted / omkar gajbare
Plz send me the dumps Mukesh
omkargajbare@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are active transformations.
What is standalone command task?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is an Integration service in Informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain direct and indirect flat file loading (source file type) - informatica
What differs when we choose the sorted input for aggregator transformation?
What is the surrogate key?
Is it possible to use a client with different version than that of its Informatica server?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?