Answer Posted / nikita jain
yes, In Target design tab of Designer there are options like import from flatfiles also create table there we can select the type as flat file.
we can add the column names after creating the flatfile target instance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
What is the maplet?
Explain your project of banking domian.
Explain the pipeline partition with real time example?
What is informatica metadata and where is it stored?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain pushdown optimization $pushdownconfig parameter - informatica
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.
What is a mapplet/worklet in informatica?
Where do we use mapping variables in informatica?
Explain the mapping variable usage example in informatica
What is the surrogate key?
What is dimensional table? Explain the different dimensions.
What are the data movement modes in informatica?
Name the different lookup cache(s)?