1. I have a source column data with names like ravi kumar.i want to insert the ravi in one column and kumar in another coliumn of target table.how do u implement in informatica?
2. Doubts regarding rank transformation: CAn we do ranking using two ports? can we rank all the rows coming from source, how?
3. I have a source column table data as basha?kammur.i want to insert basha in one column of target table and kammur in another column of target table.how to implement in informatica.(This is a Interview Question asked in IBM)?
4. HOW CAN WE SAY THAT UNION TRANSFORMATION IS AN ACTIVE TRANSFORMATION? CAN U PLZ GIVE ME AN EXAMPLE.
5. What is the feature of etl tool in market,which tool occupies more area in market,
6. 1.what is the diff b/w rowid and row? 2.diff b/w rowid and row number?
7. What are the mapings that we use for slowly changing dimension table?
8. What is the hierarchies in DWH
9. How can we store previous session logs
10. my source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this problem.
11. What is mystery dimention?
12. What is Dimension table Exactly?
13. What are the data movement modes in informatcia?
14. What are the different threads in DTM process?
15. What is a junk dimension
16. What r the circumstances that infromatica server results an unreciverable session?
17. Explain about perform recovery?
18. What is Load Manager?
6.
How
to load the data from people soft hrm to people soft erm using informatica?
7.
How
many number of sessions that You can create in a batch?
8.
Compare
Data Warehousing Top-Down approach with Bottom-up approach
9.
What
r the methods for creating reusable transforamtions?
10.
How
can u recognise whether or not the newly added rows in the source r gets insert
in the target ?
11.
How
to export mappings to the production environment?
12.
where
do we use MQ series source qualifier, application multi group source qualifier.
just give an example for a better understanding
13.
How
do we estimate the depth of the session scheduling queue? Where do we set the
number of maximum concurrent sessions that Informatica can run at a given time?
14.
What
are the Differences between Informatica Power Center versions 6.2 and 7.1, also
between Versions 6.2 and 5.1?
15.
Discuss
which is better among incremental load, Normal Load and Bulk load
16.
What
happens if you try to create a shortcut to a non-shared folder?
17.
Somebody
ca explain me the 3 points:I want to Know : 1) the differences between using
native and ODBC server-side databaseConnections 2)Know the reason why to
register a server to the repository is necessary 3)Know the rules associated
with transferring and sharing objects between folders. 4) Know the rules
associated with transferring and sharing objects between repositories
18.
What
is Micro Strategy? Why is it used for? Can any one explain in detail about it?
19.
what
is the best way to show metadata(number of rows at source, target and each
transformation level, error related data) in a report format
20.
When
the informatica server marks that a batch is failed?
21.
Why
we use partitioning the session in informatica?
22.
Which
tool you use to create and manage sessions and batches and to monitor and stop
the informatica server?
23.
What
is Code Page Compatibility?
24.
how
can you assign a index for a particular column? how do you choose which colum
is the best to create index?
25.
What
is the mapping for unit testing in Informatica, are there any other testings in
Informatica, and how we will do them as a etl developer. how do the testing
people will do testing are there any specific tools for testing
26.
Can
any body write a session parameter file which will change the source and
targets for every session. i.e different source and targets for each session
run.
27.
What
is meant by Junk Attribute in Informatica?
28.
What
are partition points?
29.
How
to delete duplicate rows in flat files source is any option in informatica
30.
Which
transformation should we use to normalize the COBOL and relational sources?
31.
Where
should U place the flat file to import the flat file defintion to the designer?
32.
I
have flatfile it contains ‘n’ number of records. i need to load half of the
records to one target table another half to another target table. plz any one
can explain me the procedure.
33.
How
can u recover the session in sequential batches?
34.
What
are the scheduling options to run a sesion?
35.
What
is power center repository?
36.
If
the workflow has 5 session and running sequentially and 3rd session hasbeen failed
how can we run again from only 3rd to 5th session?
37.
How
to use mapping parameters and what is their use
38.
Diff
between informatica repositry server & informatica server
39.
How
many ways you can update a relational source defintion and what r they?
40.
What
r the mapping paramaters and maping variables?
41.
Differences
between connected and unconnected lookup?
42.
What
is a source qualifier?-
43.
How
to load the data from people soft hrm to people soft erm using informatica?
44.
How
many number of sessions that You can create in a batch?
45.
When
we create a target as flat file and source as oracle.. how can i specify first
rows as column names in flat files…
46.
How
do you create a mapping using multiple lookup transformation?
47.
To
provide support for Mainframes source data,which files are used as a source
definitions?
48.
Explain
about Recovering sessions?
49.
Can
Informatica load heterogeneous targets from heterogeneous sources?
50.
While
running multiple session in parallel which loads data in the same table,
throughput of each session becomes very less and almost same for each session.
How can we improve the performance (throughput) in such cases?
51.
Can i
use a session Bulk loading option that time can i make a recovery to the
session?
52.
What
is data merging, data cleansing, sampling?
53.
There
are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with
some 30 and so. i want to diplay those deptno where more than 10 people exists
54.
I
have an requirement where in the columns names in a table (Table A) should
appear in rows of target table (Table B) i.e. converting columns to rows. Is it
possible through Informatica? If so, how?
55.
In
the source, if we also have duplicate records and we have 2 targets, T1- for
unique values and T2- only for duplicate values. How do we pass the unique
values to T1 and duplicate values to T2 from the source to these 2 different
targets in a single mapping?
56.
What
is the procedure or steps implementing versioning if you are already in
version7.X. Any gotcha’s or precautions..
57.
What
is the default join that source qualifier provides?
58.
Can
any one tell me how to run scd1 bec it create two target tables in mapping
window and there are only one table in warehouse designer(means target).. so if
we create one new table in target it gives error..
59.
i
have source like 1;2:3.4 its flatfile. now i want in my target table as 1 2 3 4
plz can any one explain me the procedure how to get output like dat
60.
In a
sequential batch can you run the session if previous session fails?
61.
What
are the types of groups in Router transformation?
62.
How
do you transfert the data from data warehouse to flatfile?
63.
Define
Informatica Repository?
64.
What
is change data capture?
65.
How
is the union transformation active transformation?
66.
Can
batches be copied/stopped from server manager?
67.
Can
we add different work flows in to one batch and run sequentially? If pos how do
we do that?
68.
How
to retrive the records from a rejected file. explane with syntax or example
69.
What
is the look up transformation?
70.
Explain
the informatica Architecture in detail
71.
What
r the reusable transforamtions?
72.
What
are the scheduling options to run a sesion?
73.
I was
working in SQL server, now i got an golden opertunity to work in INFORMATICA. I
have lots of (silly) Questions to build my Career, so pls guide me properly. I
will ask lots of questions…. What is the process flow of informatica,
74.
What
is a time dimension? give an example.
75.
What
r the types of metadata that stores in repository?
76.
How
can we join 3 database like Flat File, Oracle, Db2 in Informatrica..
100.How i can do incremental aggregation in
real time?
101.Identifying bottlenecks in various
components of Informatica and resolving them.
102.If i done any modifications for my table in
back end does it reflect in informatca warehouse or maping desginer or source
analyzer?
103.After draging the ports of three
sources(sql server,oracle,informix) to a single source qualifier, can u map
these three ports directly to target?
104.Informatica Live Interview Questions
105.Why you use repository connectivity?
106.How the informatica server increases the
session performance through partitioning the source?
107.How to join two tables without using the
Joiner Transformation.
108.What is the maplet?
109.How many ways you can update a relational
source defintion and what are they?
110.what is the look up transformation?
111.What is Router transformation?
112.What r the different types of Type2
dimension maping?
113.What is the difference between PowerCenter
6 and powercenter 7?
114.What is exact use of ‘Online’ and ‘Offline’
server connect Options while defining Work flow in Work flow monitor? . The
system hangs when ‘Online’ server connect option. The Informatica is installed
on a Personal laptop.
115.Can any one explain real time complain
mappings or complex transformations in Informatica. Specially in Sales Domain.
116.How to append the records in flat
file(Informatica) ? Where as in Datastage we have the options i) overwrite the
existing file ii) Append existing file
117.Why dimenstion tables are denormalized in
nature ?
118.Which is better among connected lookup and
unconnected lookup transformations in informatica or any other ETL tool?
119.Which transformation should u need while
using the cobol sources as source defintions?
120.What is Session and Batches?
121.Can u generate reports in Informatcia?
122.How to recover the standalone session?
123.Where is the cache stored in informatica?
124.Can we run a group of sessions without
using workflow manager
125.What is metadata reporter?
126.What is the Router transformation?
127.Which transformation should you need while
using the cobol sources as source defintions?
128.What r the connected or unconnected
transforamations?
129.Can U use the maping parameters or
variables created in one maping into another maping?
130.Why we use stored procedure transformation?
131.How to load time dimension?
132.After draging the ports of three
sources(sql server,oracle,informix) to a single source qualifier, can u map
these three ports directly to target?
133.Can u copy the session to a different
folder or repository?
134.What is Partitioning ? where we can use
Partition? wht is advantages?Is it nessisary?
135.What is meant by EDW?
136.What are the properties should be notified
when we connect the flat file source definition to relational database target
definition?
137.In realtime which one is better star schema
or snowflake star schema the surrogate will be linked to which columns in the
dimension table.
138.What is the exact meaning of domain?
139.What is difference between partioning of
relatonal target and partitioning of file targets?
140.If I get a flat file as source, I need to
get distinct data in the target. How do I accomplish this? Please give a
detailed answer of what all trasformations we have to use and how the data flow
will be, and what SQL statement we have to use.
141.What is Data Transformation Manager?
142.How can u work with remote database in
informatica?did u work directly by using remote connections?
143.How is the union transformation active
transformation?
144.What is lookup transformation and update
strategy transformation and explain with an example.Thanks in Advance
145.How do you handle decimal places while
importing a flatfile into informatica?
146.What is batch and describe about types of
batches?
147.Differences between Informatica 6.2 and
Informatica 7.0 Yours sincerely
148.Which tool U use to create and manage
sessions and batches and to monitor and stop the informatica server?
149.Can u start a batches with in a batch?
150.What is incremantal aggregation?
151.What is meant by complex mapping
152.Can i start and stop single session in
concurent bstch?
153.Can you start a session inside a batch
idividually?
154.Can we use aggregator/active transformation
after update strategy transformation
155.Can you copy the batches?
156.Why we use stored procedure transformation?
157.can any one comment on significance of
oracle 9i in informatica when compared to oracle 8 or 8i. I mean how is oracle
9i advantageous when compared to oracle 8 or 8i when used in informatica
158.How many ways you create ports?
159.What r the joiner caches?
160.What is Load Manager?
161.What r the types of metadata that stores in
repository?
162.Could anyone please tell me what are the
steps required for type2 dimension/version data mapping. how can we implement
it
163.In which circumstances that informatica
server creates Reject files?
164.What is DTM process?
165.Suppose session is configured with commit
interval of 10,000 rows and source has 50,000 rows. Explain the commit points
for Source based commit and Target based commit. Assume appropriate value
wherever required.
166.What are the types of maping wizards that
are to be provided in Informatica?
1.
Describe
two levels in which update strategy transformation sets?
168.What is the limit to the number of sources
and targets you can have in a mapping
169.Difference between summary filter and
details filter?
170.What are the reusable transforamtions?
171.What r the types of maping wizards that r
to be provided in Informatica?
172.How can we eliminate duplicate rows from
flat file?
173.If a session fails after loading of 10,000
records in to the target.How can u load the records from 10001 th record when u
run the session next time in informatica 6.1?
174.How to create the staging area in your
database
175.What is aggregate cache in aggregator
transforamtion?
176.Why and where we are using factless fact
table?
177.How can we join the tables if the tables
have no primary and forien key relation and no matchig port to join?
178.What is worklet and what use of worklet and
in which situation we can use it
179.What will happen if you are using Update
Strategy Transformation and your session is configured for “insert”? What are
the types of External Loader available with Informatica? If you have rank index
for top 10. However if you pass only 5 records, what will be the output of such
a Rank Transformation?
180.Which objects are required by the debugger
to create a valid debug session?
181.How do you decide whether you need ti do
aggregations at database level or at Informatica level?
182.How can i transform row to column?
183.How to get the first 100 rows from the flat
file into the target?
184.What is Data cleansing..?
185.Which tool U use to create and manage
sessions and batches and to monitor and stop the informatica server?
186.Can u start a batches with in a batch?
187.What is incremantal aggregation?
188.What is a command that used to run a batch?
189.What are the unsupported repository objects
for a mapplet?
190.What is aggregate cache in aggregator
transforamtion?
191.What r the types of lookup caches?
192.What are Aggregate transformation?
193.How do we analyse the data at database
level?
194.Can u tell me how to go for SCD’s and its
types.Where do we use them mostly
195.I have a situation here to load the Table
into informatica. I have 5 temporary tables as sources. They look like: Table1:
(K – Key, N-Null, X,Y,Z – values) K1 X N N N N K2 X N N N N ————————– Table2:
K1 N X N N N K2 N X N N N ————————– the other 3 tables are in the same way. But
there can be a situation like any of the table can contain duplicates like: K1
X N N N N K1 Y N N N N ————————– This kind of records should be errored out.
Because of this, we can’t use aggregator/group by as we are not sure which one
should be removed. How can we obtain this functionality in Informatica.
196.In my source table 1000 rec’s r there.I
want to load 501 rec to 1000 rec into my Target table ? how can u do this ?
197.If you want to create indexes after the
load process which transformation you choose?
198.If you are workflow is running slow in
informatica. Where do you start trouble shooting and what are the steps you
follow?
199.Can we lookup a table from a source
qualifer transformation-unconnected lookup
200.What r the tasks that Loadmanger process
will do?
201.What r the active and passive
transforamtions?
202.What is the Router transformation?
203.What are Dimensions and various types of
Dimensions?
204.Why sorter transformation is an active
transformation?
205.What are the different types of
transformation available in informatica. and what are the mostly used ones
among them
206.I want to prepare a questionnaire. The
details about it are as follows: – 1. Identify a large company/organization
that is a prime candidate for DWH project. (For example Telecommunication, an
insurance company, banks, may be the prime candidate for this) 2. Give at least
four reasons for the selecting the organization. 3. Prepare a questionnaire
consisting of at least 15 non-trivial questions to collect
requirements/information about the organization. This information is required
to build data warehouse. Can you please tell me what should be those 15
questions to ask from a company, say a telecom company?
1.
How
can you stop a batch?
208.What are the types of lookup?
209.To provide support for Mainframes source
data,which files r used as a source definitions?
210.I have windows xp. I was told a person
could find out what sites a person is looking on your computer. How do you do
this. I have a person who uses my computer, and I think he is looking at sites
he should not be viewing.
211.How to get two targets T1 containing
distinct values and T2 containing duplicate values from one source S1.
212.What is the difference between Power Centre
and Power Mart? What is the procedure for creating Independent Data Marts from
Informatica 7.1?
213.We are using Update Strategy Transformation
in mapping how can we know whether insert or update or reject or delete option
has been selected during running of sessions in Informatica.
214.What are the different types of Type2
dimension maping?
215.What is the need and when do we use a
dynamic lookup cache?
216.Can you use the maping parameters or
variables created in one maping into any other reusable transformation?
217.What is tracing level?
218.What is a view? How it is related to data
independence?And what are the different types of views,and what is Materialize
view
219.Define maping and sessions?
220.What are the active and passive
transforamtions?
221.What r the unsupported repository objects
for a mapplet?
222.There are 1000 source tables containing the
same data with different file formats,now i want to load into a single target
table ..how to achieve ?
223.What is source qualifier transformation?
224.What is the method of loading 5 flat files
of having same structure to a single target and which transformations I can
use?
225.What is surrogatekey ? In ur project in
which situation u has used ? explain with example ?
226.How do you load the time dimension.
227.Can you start a batches with in a batch?
228.Which transformation should we use to
normalize the COBOL and relational sources?
229.What are the measure objects
230.What are the options in the target session
of update strategy transsformatioin?
231.What are the designer tools for creating
tranformations?
232.Where should you place the flat file to
import the flat file defintion to the designer?
233.What is Code Page used for?
234.What are the rank caches?
235.Difference between static cache and dynamic
cache?
236.In which condtions we can not use joiner
transformation(Limitaions of joiner transformation)?
237.What r the basic needs to join two sources
in a source qualifier?
238.How to define Informatica server?
239.Can anyone explain about incremental
aggregation with an example?
240.How a two dimension array is initialize
with pointer?
241.What are the different options used to
configure the sequential batches?
242.What is a transforamation?
243.How to Generate the Metadata Reports in
Informatica?
244.what is difference between lookup cashe and
unchashed lookup? Can i run the mapping with out starting the informatica
server?
245.How do we estimate the number of partitons
that a mapping really requires? Is it dependent on the machine configuration?
246.What are the tasks that source qualifier
performs?
247.How the informatica server sorts the string
values in Ranktransformation?
248.What are the tasks that Loadmanger process
will do?
249.What is update strategy transformation?
250.How can u complete unrcoverable sessions?
251.What are the new features of the server
manager in the informatica 5.0?
252.What are the types of maping in Getting
Started Wizard?
253.How can you improve the performance of
Aggregate transformation?
254.How can I get distinct values while mapping
in Informatica in insertion?
255.What is polling?
256.This is a scenario in which the source has
2 cols 10 A 10 A 20 C 30 D 40 E 20 C And there should be 2 targets one to show
the duplicate values and another target for distinct rows. T1 T2 10 A 10 A 20 C
20 C 30 D Which transformation can be used to load data into target? 40 E
257.In which condtions we can not use joiner
transformation(Limitaions of joiner transformation)?
258.What is the maplet?
259.Partitioning, Bitmap Indexing (when to
use), how will the bitmap indexing will effect the performance
260.What is difference between dimention table
and fact table and what are different dimention tables and fact tables
261.What are cost based and rule based
approaches and the difference
262.How do you identify existing rows of data
in the target table using lookup transformation?
263.What is Datadriven?
264.In a scenario I want to change the
dimensions of a table and normalize the renormalized table which transformation
can I use?
265.Can you copy the session to a different
folder or repository?
266.What r the tasks that source qualifier performs?
267.What is the diff b/w STOP & ABORT in
INFORMATICA sess level ?
268.what r the settiings that u use to cofigure
the joiner transformation?
269.What is tracing level and what r the types
of tracing level?
270.What is difference between maplet and reusable
transformation?
271.What is the procedure to load the fact
table.Give in detail?
272.What is the status code?
273.Why did you use stored procedure in your
ETL Application?
274.What are variable ports and list two
situations when they can be used?
275.While importing the relational source
defintion from database, what are the meta data of source you import?
276.What is Transaction?
277.How can you access the remote source into
your session?
278.What are the new features in Informatica
5.0?
279.What are the basic needs to join two
sources in a source qualifier?
280.What are the diffrence between joiner
transformation and source qualifier transformation?
281.With out using Updatestretagy and sessons
options, how we can do the update our target table?
282.What is rank transformation?where can we
use this transformation?
283.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.
284.What are the joiner caches?
285.What are the settiings that you use to
cofigure the joiner transformation?
286.What transformation you can use inplace of
lookup?
287.What is a source qualifier?
288.what r the settiings that u use to cofigure
the joiner transformation?
289.What is tracing level and what r the types
of tracing level?
290.What is difference between maplet and
reusable transformation?
291.What is the procedure to load the fact
table.Give in detail?
292.What is the status code?
293.Why did you use stored procedure in your
ETL Application?
294.What are variable ports and list two
situations when they can be used?
295.While importing the relational source
defintion from database, what are the meta data of source you import?
296.What is Transaction?
297.How can you access the remote source into
your session?
298.What are the new features in Informatica
5.0?
299.What are the basic needs to join two
sources in a source qualifier?
300.What are the diffrence between joiner
transformation and source qualifier transformation?
301.With out using Updatestretagy and sessons
options, how we can do the update our target table?
302.What is rank transformation?where can we
use this transformation?
303.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.
304.What are the joiner caches?
305.What are the settiings that you use to
cofigure the joiner transformation?
306.What transformation you can use inplace of
lookup?
307.What is a source qualifier?
308.How many types of dimensions are available
in Informatica?
309.Define informatica repository?
310.How do you configure mapping in informatica
311.In Dimensional modeling fact table is
normalized or denormalized?in case of star schema and incase of snow flake
schema?
312.How can you create or import flat file
definition in to the warehouse designer?
313.When we create a target as flat file and
source as oracle.. how can i specify first rows as column names in flat files…
314.Discuss the advantages & Disadvantages
of star & snowflake schema?
315.Difference between Rank and Dense Rank?
316.What is update strategy transformation ?
317.How can we partition a session in
Informatica?
318.Can anyone explain error handling in
informatica with examples so that it will be easy to explain the same in the
interview.
319.What is the difference between connected
and unconnected stored procedures.
320.Which tasks can be performed on port
level(using one specific port)?
321.When do u we use dynamic cache and when do
we use static cache in an connected and unconnected lookup transformation
322.Waht are main advantages and purpose of
using Normalizer Transformation in Informatica?
323.What is the difference between constraind
base load ordering and target load plan
324.What is source qualifier transformation?
325.What is difference between IIF and DECODE
function
326.When do u use a unconnected lookup and
connected lookup…. what is the difference between dynamic and static lookup…y
and when do v use these types of lookups ( ie…dynamic and static )
327.SCD Mappings are mostly used Unconnected
Lookup Transformation. Unconnected Lookup used static Cache only.At this time
how can you insert or update date in Target by using static cache?
328.How to recover sessions in concurrent
batches?
329.Why we use lookup transformations?
330.What is Datadriven?
331.What is batch and describe about types of
batches?
332.Can Informatica be used as a Cleansing
Tool? If Yes, give example of transformations that can implement a data
cleansing routine.
333.On a day, I load 10 rows in my target and
on next day if I get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert and update the
record?
334.Differences between connected and
unconnected lookup?
335.How to read rejected data or bad data from
bad file and reload it to target?
336.1)What are the various test procedures used
to check whether the data is loaded in the backend, performance of the mapping,
and quality of the data loaded in INFORMATICA. 2) What are the common problems
developers face while ETL development
337.What are the types of data that passes
between informatica server and stored procedure?
338.How to move the mapping from one database
to another?
339.What is the target load order?
340.Can we eliminate duplicate rows by using
filter and router transformation ?if so explain me in detail .
341.Briefly explian the Versioning Concept in
Power Center 7.1.
342.To achieve the session partition what are
the necessary tasks you have to do?
343.Can you use the maping parameters or
variables created in one maping into another maping?
344.What are the types of metadata that stores
in repository?
345.What is the default join that source
qualifier provides?
346.what are the difference between view and
materialized view?
347.What is difference between stored procedure
transformation and external procedure transformation?
348.How to use the unconnected lookup i.e.,
from where the input has to be taken and the output is linked? What condition
is to be given?
349.What is the Rankindex in
Ranktransformation?
350.What is difference between partioning of
relatonal target and partitioning of file targets?
351.At the max how many tranformations can be
us in a mapping?
352.why did u use update stategy in your
application?
353.What is IQD file?
354.What r the mapings that we use for slowly
changing dimension table?
355.How do I import VSAM files from source to
target. Do I need a special plugin
356.What is meant by aggregate fact table and
where is it used?
357.What are Target Types on the Server?
358.What are mapping parameters and varibles in
which situation we can use it
359.How do you create single lookup
transformation using multiple tables?
360.Why is meant by direct and indirect loading
options in sessions?
361.What are Target Options on the Servers?
362.What are the join types in joiner
transformation?
363.Can you generate reports in Informatcia?
364.What are two modes of data movement in
Informatica Server?
365.Explain use of update strategy
transformation
366.The designer includes a “Find” search tool
as part of the standard tool bar. What can it be used to find?
367.If you have four lookup tables in the
workflow. How do you troubleshoot to improve performance?
368.How to import oracle sequence into
Informatica.
369.What is difference b/w Informatica 7.1 and
Abinitio
370.Identifying bottlenecks in various
components of Informatica and resolving them.
371.What is parameter file?
372.What is the difference between summary
filter and detail filter
373.How can u work with remote database in
informatica?did u work directly by using remote connections?
374.What is the difference between Narmal load
and Bulk load?
375.How u will create header and footer in
target using informatica?
376.What are two types of processes that
informatica runs the session?
377.What r the types of groups in Router
transformation?
378.What are the real time problems generally
come up while doing/running mapping/any transformation?can any body explain
with example.
379.What is difference between maplet and
reusable transformation?
380.How many types of facts and what are they?
381.what are load types in informatica and what
is delta load
382.What are the session parameters?
383.What are the methods for creating reusable
transforamtions?
384.How can you say that union Transormation is
Active transformation.
385.What does the expression n filter
transformations do in Informatica Slowly growing target wizard?
386.Difference between static cache and dynamic
cache
387.Where to store informatica rejected data?
How to extract the informatica rejected data ?
