Why sequence generator is not directly connected to joiner transformation?
Latest Answer: Remember Joiner tx can accept input from only 2 pipelines.Now only following 2 scenerios possible to have both joiner and Seq Gen tx:1)2 input pipelines are already connected and then we want to connect Seq Gen to joiner: In this scenerio, the input from ...
What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?
Latest Answer: For Unsorted Input joiner transformation, i)
Data cache stores all master rows in the join condition with unque index keys ii)
Index cache stores all master rows.For Sorted Input with
Different Sources, i) Data cache stores 100 master rows in the ...
What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.
Latest Answer: DTM buffer size is memory you allocate to DTM process (12 MB)Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)And Informatica bydeault assign it to be as for 83 sources and Targets(Buffer ...
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
Latest Answer: $ is a Mapping Variable/Parameter.$$ is a Session Variable/Parameter. ...
How the data flows from dimensions to fact table?
Latest Answer: Data in reality does not flow from dimensions to facts or visa versa. Dimensions contain textual descriptive information in a business unit of an Enterprise. This kind of data is usually contained in the where clauses of your query. Informations such ...
can any one tell me How can use worklet variables and work flow variables Regards Srinu
Latest Answer: You can use them in the same way as we used session/mapping variable ...
Hi friends, I connect the pubs database and i move the data to the target successfully. but i connect the Northwind as the same procedure but the task is failed. I don't know what
Latest Answer: Use :LKP.transformation_name(column1,col2,...) ...
Same machine is using more than one user at different time, how to identify whether an particular user used a folder or not
Latest Answer: You can check out this options in Repository Manager.Open the Edit tab and select the option Show User Connections where you can find the information related to the users , connection_id and the time they logged in and the host address ...etc. If ...
What are the transformations not used in mapplet and why?
Latest Answer: Normalizer transformationXML source qualifierXML filesOther targets.If
you need to use sequence generator transformation use the reusable sequence gen t/rIf
you need to use stored procedure transformation, make the stored procedure type as normal. ...
Can we load data from a pdf to a table using informatica.
Latest Answer: Yes, you can load data from a pdf to a table using UDO[Unstructured Data Option] Transformation in Informatica from PC811 onwards ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
