Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
2127We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
3 12931I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
1961I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
1 3700hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
IBM,
9902My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
1994Post New Informatica Questions
Enlist the differences between database and data warehouse.
How to load a Dimension ? and how to load a fact table?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What do you understand by term role-playing dimension?
What is a rank transform?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In informatics server which files are created during the session rums?
What all join we can perform in LOOKUP transformation?
How would you join a node to the already existing domain?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is meant by target load plan?
server hot-ws270 is connect to Repository B. What does it mean?
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 .
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a code page?