-
What is source qualifier transformation?
When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session.
ASHOK1324
- Apr 21st, 2009
It is a transformation which is automatically generated to read the data from source tables into informatica designer.
jaber
- Dec 9th, 2007
Source Qualifier is a transformation with every source definiton if the source is Relational Database.Source Qualifier fires a Select statement on the source db.With every Source Definition...
-
What is the default join that source qualifier provides?
Inner equi join.
-
What is the difference between source qualifier transformation and filter transformation?
manoj_behera82
- Nov 9th, 2009
Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well. It is capable ...
divakar
- Nov 5th, 2007
A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted? from this? transformation after connecting to the?...
-
-
Compare Data Warehousing Top-Down approach with Bottom-up approach
vikota
- Apr 12th, 2011
Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific subject are called datamartsBottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse
samirdesai999
- Jun 13th, 2009
Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...
-
How to join two tables without using the Joiner Transformation.
ram_infa
- Sep 14th, 2011
If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.
vikota
- Apr 12th, 2011
If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table
-
-
What is the difference between power center and power mart?
1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
pasupula.naidu
- Dec 31st, 2010
For mapping parameters create a notepad file like this way, Sysntax:------------- [foldername.WF:workflow_name.ST:session_name] $$para_name=valuefor session parameters,sysnatx:-----------[...
hundwanipankaj
- Apr 5th, 2010
Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. Power center is used for corporate enterprise data warehouse and power mart is...
-
-
How can U improve session performance in aggregator transformation?
Use sorted input.
manoj_behera82
- Jul 20th, 2010
1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.2. Reduce the input/output ports in the aggregator.3.Can try increasing the cache size.
job_infa
- Jan 28th, 2009
-Use sorted input to decrease the use of aggregate caches.-Limit connected input/output or output ports.Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.-Filter the data before aggregating it.
-
What is Dataware house key?
dl_mstr
- Feb 10th, 2008
Surrogate key is know as datawarehouse key. Surrogate key is used as a unique key in warehouse where dupicate keys may exits due to type 2 changes.
shanthi1
- Mar 18th, 2007
There is a Dataware house key........plz go thru kimball bookEvery data warehouse key should be a surrogate key because the data warehouse DBA must have the flexibility to respond to changing descriptions and abnormal conditions in the raw data.
-
Where and how you use UNIX Shell script in informatica
Can any one explain where we use Unix shell Scripts in informatica? Provided with example if possible.Thanks.......Jc
sum
- Oct 8th, 2015
1] To archive file
2] To create parameter file dynamically at run time
3] To have control and audit for source file/tables
4] To purge old files from server
savaram5553
- May 28th, 2015
Hi Nithin will you help me with batch script to bounce the informatica and DAC services.
-
Discuss which is better among incremental load, Normal Load and Bulk load
Read Best Answer
Editorial / Best Answer
gazulas- Member Since Jan-2006 | Jan 29th, 2006
if supported by the database bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)
ram_infa
- Sep 14th, 2011
It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..
vikota
- Apr 12th, 2011
Incremental load: Incremental means suppose today we processed 100 records ,for tomorrow run u need to extract whatever the records inserted newly and updated after ...
-
Hi all, recently i was asked by the interviewer like,in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.how to do this. if any one knows how to do this pls. reply.thankskumar
dashingcar
- Apr 19th, 2010
PowerCenter 8.1.1 Performance Tuning Guide The Integration Service looks for the start value of the Variable in the following order: 1.Value in parameter file 2.Value saved in the repository 3.Initial...
-
How can we delete duplicate rows from flat files ?
Srinivas Kumar Paga
- Jan 23rd, 2007
Use Sorter Transformation and check "Distinct" option. It will remove the duplicates.
manisha.sinha
- Dec 29th, 2006
In the mapping read the flat file through a Source Definition and SQ. Apply a Sorter Transformation , in the property tab , select distinct . out put will give a sorter distinct data , hence you get r...
-
What is the main difference between mapping and mapplet designer ?
What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?
-
Why sorter transformation is an active transformation?
jayapraveen
- Jun 21st, 2012
Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive
vishalkrishan
- Jun 19th, 2012
The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.
-
-
1)how can we delete the cache files while we using aggregator transformaation?2)exlain about cache files handling in informatica3) there are two flat files and the two flat files contain two fileds as states.both the flat files contain duplicates how to eliminate this duplicates?4) can we use lookup transformation with out using source qualifier transformation?
jayapraveen
- Oct 13th, 2010
1.I think DTM remes the Cache files after successful loading the data into target2.a.persistent cache b.staic cache c.shared cache d.dynamic cache3.sorter befo...
chandrarekha
- Sep 28th, 2007
After the session executes,??DTM removes?the cache memory and deletes cachefiles Incase of persistant cache and incremtal aggregation cache files are saved.Generally cache files are created in Info...
-
Hw to work with pmcmd on windows platform
Joe
- Feb 7th, 2013
ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW
dl_mstr
- Feb 11th, 2008
C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe
Informatica Interview Questions
Read Best Answer
Ans