-
Lookup Query
What kind of join (Inner,Outer,FULL) does a lookup generate while being used in a mapping in order to search for a particular field value?
prashant.baranwal
- Sep 5th, 2010
When used in mapping, is generates a inner join by default. However when it returns the value to the system, it does returns a NULL for unmatched records. So we can say that it is left outer join. So we must make sure in which context the question is asked.
-
$ symbol
$, $$, $$$ what these symbols represents in Informatica?
prashant.baranwal
- Sep 5th, 2010
$ is Session Parameter, Ex: $DBConnection$$ is mapping Parameter/Variable, Ex: $$LastRunDate$$$ is system variable, Ex: $$$SessStartTime
saravanakumar.ashokan
- Aug 29th, 2010
single $ denotes System variableDouble $$ denates User-defined variableTriple $$$ denotes Session Varaiables..You can read on mapping parameter & varaiable in de...
-
Time Dimension
How to load time dimension using Informatica?
laltho
- Aug 29th, 2010
My understanding is time dimension can be loaded by using stored procedure, No live project experience, got info from reading material.
-
-
Mapping and Session Migration
How can we migrate mappings and session from Informatica 6.2 to Informatica 7.1?
-
-
-
What is Router transformation?
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
pradeeshkumar
- Aug 19th, 2010
Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.But Router transformati...
YugandharS
- Jun 17th, 2010
Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.
-
Normal / Master Outer Join
Why row type should be used only with Normal/Master Outer Join?
pradeeshkumar
- Aug 19th, 2010
In normal join only matching rows from both the master and detail table will be joined and in the case of master outer join all rows from the detail table will be kept and only matching rows from the ...
-
What is the basic language of informatica?
pradeeshkumar
- Aug 19th, 2010
The Informatica's basic Language is SQL(Structered Query Language). It generates sql queries and that is executed against the database.Informatica is just a tool, that generates SQL queries based on the conditions you specify.
Sravan Gopisetty
- Sep 24th, 2006
The basic language of Informatica is SQL plus.Then only it will under stand the data base language.
-
1) How to load the data (like refresh load, quarterly load, hourly load etc)2) what is lookup ? (Lookup is a join is it wright or wrong)ub
pradeeshkumar
- Aug 19th, 2010
Lookup is not a join. Lookup is?more?similar to the real world example,?you?are conducting a interview and you?have?the list of registered candidates in hand.?In oreder to see whether a candidate is registered or not, you'll look into the list and then verify. That's it.
-
In workflow can we send multiple email ?
WMC
- Oct 9th, 2006
Yes, only on the UNIX version of Workflow and not Windows based version.
-
Which transformation has the most complexity Lookup or Joiner?
pradeeshkumar
- Aug 19th, 2010
Its not that complexity associated with the transformation. Its just how far you know to use which transformation is suitable for solving a problem.
sai
- Feb 14th, 2007
Lookupbut it will reduse the complexity of the solutions and improves the performance of the workflows.
-
At what frequent u load the data?
pradeeshkumar
- Aug 19th, 2010
The frequency of loading data is based on the needs. It may be once in a week or at every nights.
opbang
- Oct 4th, 2006
Loading frequency depends on the requirement of Business Users, It could be daily during mid night... or weekly... Depending on the frequency... ETL process should take care... how t...
-
What is the default source option for update stratgey transformation?
Data driven.
Gyaneshwar
- Mar 28th, 2006
DATA DRIVEN
-
What r the unsupported repository objects for a mapplet?
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source definitions IBM MQ source defintions
kvrp461
- Aug 18th, 2010
1)Stored procedure preload or postload is not possible.2)Dont allow the not reusable sequence generator.3)xml source qualifier4)Normalizer5)Nested mapplets
job_infa
- Jan 28th, 2009
−Normalizer transformations−Cobol sources−XML Source Qualifier transformations−XML sources−Target definitions−Pre- and post- session stored procedures−Other mapplets-PowerMart 3.5-style LOOKUP functions-non reusable sequence generator
-
What r the connected or unconnected transforamations?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.
kvrp461
- Aug 18th, 2010
Connected: The transformation is?participated in the flow of data from source to target.Unconnected: The transformation is not?participated in the flow of data from source to target.
chandrarekha
- Sep 12th, 2007
Connect Transformation :A transformation which participates in the mapping data flow Connected transformation can receive multiple inputs and provides multiple outputsUnconnected : A unconnected...
-
How do you maintain Historical data and how to retrieve the historical data?
kvrp461
- Aug 13th, 2010
In SCD Type2 we want to maintain the historical as well as current data.By using surrogate key or sequence generated key to maintain this historical data on to the target tables.
Thananjayan
- Nov 17th, 2007
You can maintain the historical data by desing the mapping using Slowly changing dimensions types.If you need to insert new and update old data,best go for Update strategy.If you need to maintain the ...
-
Main data object in between Source and Target
What is the main data object present in between Source and Target.
N SRIRAM K
- Apr 14th, 2008
Stage..where we can transform the source data and will load into TGT.Thx SRIRAM N
-
Pivoting
How to get pivot using expression transformation?
Informatica Interview Questions
Ans