-
What is intermediate task in informatica? In what situation this task will be executed?
-
Assignment task in informatica
What is Assignment task in informatica? In what situation this task will be executed? Where this task exits?
mdahiya81
- Feb 6th, 2008
The Assignment task allows you to assign a value to a user-defined workflow variable. To use an Assignment task in the workflow, first create and add the Assignment task to the workflow. Then config...
-
Which transformation useful for joining the multi table..........
I am retrieving the multi structures from source i want to define single target table structure for this which transformation i need to follow
-
ETL Design Complex Logic
What is the most complex logic you have used in your ETL design?
-
How to link informatica with database (oracle or sql server)
Hello,could anyone please guide me ,how to link with database(oracle database or sql server),iam new to informatica, please tell me the path to link these 2 because iam practising in my homewith my computer.please anyone help me.rkumar_123thanks in advance
manojkumarkurnool
- Feb 13th, 2008
hi to all infomatica people in order to link infomatica with database an infomatica developer or etlconsutant has to use ODBC Connections (open database connectivity driver)which are their in infomati...
-
Upgrading the mappings from Informatica 7.1.3 to Informatica 8
What are the advantages and disadvantages (if any) of upgrading the mappings from Informatica 7.1.3 to Informatica 8
raj_infadev
- Oct 13th, 2008
hi thereits not the matter of advantages or disadvantages for upgrading. its all depends on client requirement. if the client feel that using higer version is more comfortable and ease of use and...
-
Run sessions
How do you run sessions one after another?
pal.amol
- Feb 25th, 2008
There are two methods for running the session one is to run concurrently and second one is to run sequentially which you want to do. There are three things need to be configured at properties lev...
-
Sorter in Active Transformation
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
MMSheriff
- Feb 27th, 2008
Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records
-
Informatica Dynamic Source and Target
Similar to creating dynamic target can we create dynamic source?
-
Use VSAM file as Target in Informatica
Is it possible to have VSAM file as target? If yes can you suggest me how this can be done?
aniban
- May 10th, 2008
I believe (although not 100% sure) that this is possible. Several years back in one of the projects we had used a tool called STRIVA which could directly read/write in the form of VSAM files. Lately I...
-
Delete Informatica repository
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
hasim_geek
- Jun 6th, 2008
To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager.
-
Commenting of stored procedure
I need to comment the stored procedure in the mapping
-
Repository Backup
What is the extension used to store backup of repository?
-
Folder Access
Same machine is using more than one user at different time, how to identify whether an particular user used a folder or not
varma.dantuluri
- Jul 9th, 2008
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 ...
-
Connections and Session
How to make the connections and How to run in session?
ps77322
- Nov 5th, 2009
Connection String Creation:First go to the Work flow manager and then select your folder, then go to Connections menu and select Relational and select the type of database from the drop down and ...
-
Normalizer transformation
How do we normalize data which is in .txt comma seperated by using Normalizer transformation and storing the data in a Dimentional table?
ebullientabhinav
- Jun 22nd, 2010
Use a file delimiter as ',' comma when importing the file.The comma separated rows will now be now converted into columns which you have to name.Use normalizer now where you want
-
Mapping Parameters
How can we use mapping parameters?
naidubava
- Sep 17th, 2008
Mapping Parameters: Mapping parameter is a constant value which points to any datatype in the entire mapping. its value will not be changed as earlier said. Mapping variable: Mapping variable is same ...
-
Active and Passive Mapplet
What are active mapplet and passive mapplet?
sarita.harsh
- Mar 12th, 2009
A mapplet can be active or passive depending on the transformations in the mapplet. Active mapplets contain one or more active transformations. Passive mapplets contain only passive transformations. W...
-
Sorting Data in SQ and SRT Transformation
What is the difference between sorting data in SQ and SRT transformation?
prashastha
- Nov 12th, 2008
The difference for sorting the data in source qualifier and sorter transformation is that:If your source is relation then you can sort the data in both both transformation.But your source is file then you can only sort those data in Sorter transformation.regards....Prabhu S
-
Import Mapping
How to import mapping from one repository to another repository?
priya.kush
- Jan 9th, 2009
You can use repository manager for the same.Open the repositories drag and drop the mapping from one repository to other.
Informatica Interview Questions
Ans