Why is meant by direct and indirect loading options in sessions?
Answer Posted / raj
we use file type direct when we are loading single file into
target. we use Indirect when we want to load multiple files
through single session.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
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 are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Define the various join types of joiner transformation?
What is xml source qualifier transformation in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many ways a relational source definition can be updated and what are they?
How are the sources and targets definitions imported in informatica designer?
Do you find any difficulty while working with flat files as source and target?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Separate from a database, an information bazaar, and an information stockroom?
what is Active lock explain
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain what transformation and how many are there in informatica?