-
-
How many mappings you have done in your project(in a banking)?
jayapraveen
- Oct 12th, 2010
In a banking project if we are dealing with a Customer information ModuleThen we require4 dimensions7 Fact tablesminimum of 45 mappings requiredsize of Database is 9GB required
Whatever
- Mar 19th, 2007
Exactly 93.133
-
What is the staging database.
akmohanty
- Feb 14th, 2007
Staging database is the storage area of data. it does cleans the data, transform,combine and prepare the source data to the data mart area or data ware house.
manju
- Jan 12th, 2007
Staging database is the storage area. it clean the data, transform,combine and prepare the source data to the data mart or data ware house. staging area is in b/w the source database ...
-
-
1)What are the various test procedures used to check whether the data is loaded in the back end, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development
dl_mstr
- Feb 10th, 2008
To check data loaded in the backend can be done by collecting the session results from the reposistory tablesquality of dataloaded can be done by writing sql qureries on the target table.To Check perf...
tomtwj
- Mar 14th, 2007
Performance, Data quality, consistensy and exception handling, large various source types.
-
How to parse characters using functions in the expression transformation. For example if a column has character like mgr=a. I have to parse the character 'mgr='. Which function should I use?
kanak3
- Mar 27th, 2007
Pal....We can not use charcode() function here.When you configure the PowerCenter Server to run in ASCII mode, CHRCODE returns thenumeric ASCII value of the first character of the string passed to the...
pal
- Mar 6th, 2007
Use chrcode().
-
Explain pmcmd?
sridhar39
- Dec 29th, 2007
hi PMCMD means program command line utility. it is a program command line utility to communicate with informatica server. &...
chandrarekha
- Sep 28th, 2007
It a command line program. It performs the following tasksStart and stop the session and batchesStop the Informatica ServerChecks whether the server is working or not
-
How can I use multiple filter transformations? How do I pass dropped rows to next filter transformation to check the conditions?
Rajarao marisa
- May 31st, 2012
Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...
srinuraj
- May 31st, 2010
You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...
-
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformation error(2) A reusable unconnected Lookup can not have more than one instance in a mapping(3) An unconnected Lookup transformation does not support user-defined default values(4) An unconnected Lookup transformation does not support a static lookup cache
prashant.baranwal
- Sep 19th, 2010
What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformati...
vivek.gce
- Oct 16th, 2008
If there is no match in the Lookup condition, the Informatica server returns a transformation error.
-
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
rakesh
- Jul 20th, 2016
No because if given in a tabular form then it would easily understandable and readable
anilkumarin1
- Dec 30th, 2008
A shortcut is a reference (link) to an object in a shared folder, these are commonly used for sources and targets that are to be shared between different environments / or projects. A shortcut is crea...
-
Eliminate Duplicate Records
HiI am having 10000 records in flat file, in that there are 100 records are duplicate records..soo we want to eliminate those records..which is the best method we have to follow.RegardsMahesh Reddy
avneeshrathor
- Nov 3rd, 2009
Using sorter (with distinct option checked) will not tell what all records were duplicate. There is even a better way of doing it without using aggregator and all. it just uses expression transformation.
-
Why do we need lookup sql override? Do we write sql override in lookup with special aim?
avneeshrathor
- Nov 3rd, 2009
For some special cases like for example, You need to select the max salary
from emp table for a particular dept. then use
"select max(salary) from emp where deptno=in_dept_no
group by deptno".
Kindly let me know if this is possible without using SQL override in lookup.
ask_kaushik
- Dec 6th, 2007
Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..
-
What is Target Update Override? What is the Use ?
ORAINFO
- Nov 18th, 2008
The Integration Service updates target tables based on key values. However, you can override the default UPDATE statement for each target in a mapping. You might want to update the target based on non...
miteshcpatel
- Sep 12th, 2008
When we don't have primary keys defined on database level. And still we need update on this target from Informatica. We neeed to define keys at informatica level and use update override in target property. This way we can update the table.
-
Find out duplicate records using aggregator
How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?
VISHNU VARDHAN
- Nov 17th, 2015
Use HAVING Condition in SELECT clause, You can write code like below to test, if it is greater than one then it is duplicate otherwise Unique.
Codepriyank_divya
- Aug 7th, 2012
Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...
-
Fact Table - Grain Facts
What are Grain Facts?
Anindya1281
- Apr 15th, 2010
In simple words grain can be considered as the lowest level in which you can store data in a table for example you want to store daily sale of a product and you have different stores so store_id ...
AVRKAM
- Jan 3rd, 2010
This is about granularity. that is, what level of data detail should be made avaialble in the dimension model. A reference to ATOMIC DATA has to be made here.Atomic data is the most expressive da...
-
Dimensional modelling vs Data modelling vs ER modelling
What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
sakthi.jaganathan
- Aug 25th, 2008
The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat file...
Mamta11
- Jul 26th, 2008
Use joiner transformation. If the structure of both the flat files is same you can also use union transformation
-
SQL Override and Lookup Override
What is the difference between SQL Override and Lookup Override
VENKATM
- Jan 2nd, 2016
You cannot use directly Union in Lookup Override. You can use in SQL Override. No join conditions in SQL Override. Join condition is compulsory in lookup.
dbseeker
- Dec 20th, 2015
Can we have a different opinion on the 4th point? "Lookup override gives only one record even though there..." A lookup can return more than one record. We could handle this using the lookup property ...
-
Routing Transformation
Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation. But when I tried to post all fields from expression to router they are by default becoming only input variables . I am unable to link these variables to an Update Strategy. What to do now???...
babushiv
- Jun 18th, 2009
All the Above answers are wright, just create port in group and name it as update if you want to update, by default a port is created, now just map into corresponding router trans from update transThanksBabu Shiv
sakthi.jaganathan
- Aug 25th, 2008
In Router transformation first you want create a group, how can you create?a group means, in expression transformation?you will?set a?flag values, you just click the group tab in router transforma...
-
Calculate max value of a column
How to calculate max value of a column without using aggregrator transformation?
dihydrox
- Dec 6th, 2008
If you just need to get the max value by the end of session (to increment a value or put at the bottom of a flat file ) you can do the following. Let's say you need to find the max value f...
jryan999
- Sep 1st, 2008
You need to feed your ports through an Aggregator Tranformation. eg.Input = salary. Not outputOutput = maximum_salary --> max(salary) - OutputConnect the maximum_salary fields to ...
Informatica Interview Questions
Ans