How many mapplets u have created? and what is the logic used
Answer Posted / ram
Mapplet is defined with set of transformation, this can be reused whenever this logic is occurred. Logic depends on those transformations according to business requirement..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to open an older version of an object in the workspace?
What is joiner transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain the difference between mapping parameter and mapping variable?
What is the cumulative sum and moving sum?
How to join three sources using joiner?
Write the unconnected lookup syntax?
What do you mean by filter transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
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.
Can we get 1st record through Informatica(without sequence number).
Define enterprise data warehousing?
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