Recent Questions
Which transformation should we use to normalize the COBOL and relational sources? view answer
Difference between static cache and dynamic cache? view answer
What are the join types in joiner transformation? view answer
In which condtions we can not use joiner transformation(Limitaions of joiner transformation)? view answer
What is the look up transformation? view answer
What are the diffrence between joiner transformation and source qualifier transformation? view answer
Why use the lookup transformation? view answer
How can you improve session performance in aggregator transformation? view answer
Can you use the maping parameters or variables created in one maping into any other reusable transformation? view answer
What is meant by lookup caches? view answer
What is source qualifier transformation? view answer
How the informatica server increases the session performance through partitioning the source? view answer
What are the settiings that you use to cofigure the joiner transformation? view answer
What are the rank caches? view answer
What is Code Page Compatibility? view answer
How can you create or import flat file definition in to the warehouse designer? view answer
What is aggregate cache in aggregator transforamtion? view answer
How can you recognise whether or not the newly added rows in the source are gets insert in the target? view answer
What are the types of lookup? view answer
What are the types of metadata that stores in repository? view answer
What happens if Informatica server doesn't find the session parameter in the parameter file? view answer
Can you access a repository created in previous version of informatica? view answer
Without using ETL tool can u prepare a Data Warehouse and maintain?
view answer
How do you identify the changed records in operational data? view answer
Why couldn't u go for Snowflake schema? view answer
Name some measures in your fact table? view answer
How many dimension tables did you had in your project and name some dimensions (columns)? view answer
How many Fact and Dimension tables are there in your project? view answer
How many Data marts are there in your project? view answer
What is the daily data volume (in GB/records)? What is the size of the data extracted in the extraction process? view answer
What is the size of the database in your project? view answer
What is meant by clustering? view answer
Whether are not the session can be considered to have a heterogeneous target is determined? view answer
Under what circumstance can a target definition are edited from the mapping designer. Within the mapping where that target definition is being used? view answer
Can a source qualifier be used to perform a outer join when joining 2 database?
view answer
If u r source is flat file with delimited operator.when next time u want change that delimited operator where u can make? view answer
If index cache file capacity is 2MB and datacache is 1 MB. If you enter the data of capacity for index is 3 MB and data is 2 MB. What will happen? view answer
Difference between next value and current value ports in sequence generator? view answer
How does dynamic cache handle the duplicates rows?
view answer
How will u find whether your mapping is correct or not without connecting session?
view answer
If you are using aggregator transformation in your mapping at that time your source contain dimension or fact? view answer
My input is oracle and my target is flat file shall I load it? How?
view answer
for a session, can I use 3 mappings?
view answer
Type of loading procedures? view answer
Are you involved in high level r low level design? What is meant by that high level design n low level design? view answer
what r the dimension load methods?
view answer
where we are using lkp b/n source to stage or stage to target? view answer
How will you do SQL tuning? view answer
did u use any other tools for scheduling purpose other than workflow manager or pmcmd?
view answer
What is SQL mass updating? view answer
what is unbounded exception in source qualifier? view answer
Using unconnected lookup how we you remove nulls n duplicates?
view answer
I have 20 lookup, 10 joiners, 1 normalizer how will you improve the session performance? view answer
What is version controlling? view answer
How is the Sequence Generator transformation different from other transformations? view answer
What are the advantages of Sequence generator? Is it necessary, if so why? view answer
What are the uses of a Sequence Generator transformation?
view answer
What is Sequence Generator Transformation? view answer
What is the difference between connected lookup and unconnected lookup? view answer
What are connected and unconnected Lookup transformations? view answer
What is a Lookup transformation and what are its uses? view answer
What is a lookup table? view answer
Where do you define update strategy? view answer
What is Update Strategy? view answer
What are the different types of Transformations? view answer
What is a transformation? view answer
What are the tools provided by Designer? view answer
What are the different types of Commit intervals? view answer
What is Event-Based Scheduling? view answer
I have the Administer Repository Privilege, but I cannot access a repository using the Repository Manager. view answer
My privileges indicate I should be able to edit objects in the repository, but I cannot edit any metadata. view answer
How does read permission affect the use of the command line program, pmcmd? view answer
I do not want a user group to create or edit sessions and batches, but I need them to access the Server Manager to stop the Informatica Server. view answer
I created a new group and removed the Browse Repository privilege from the group. Why does every user in the group still have that privilege? view answer
After creating users and user groups, and granting different sets of privileges, I find that none of the repository users can perform certain tasks, even the Administrator. view answer
What are the different types of locks? view answer
What is Local Repository?
view answer
What is a Global repository?
view answer
When should you create the dynamic data store? Do you need a DDS at all? view answer
What is Dynamic Data Store? view answer
What are Target definitions?
view answer
What are Source definitions?
view answer
What are Shortcuts?
view answer
What are Sessions and Batches?
view answer
What are Reusable transformations?
view answer
What are Transformations?
view answer
What are mapplets?
view answer
What are mappings? view answer
What are folders? view answer
What is a metadata?
view answer
What are different kinds of repository objects? And what it will contain?
view answer
What are different kinds of repository objects? And what it will contain? view answer
What is a repository?
view answer
What are the new features and enhancements in PowerCenter 5.1? view answer
What is the difference between PowerCenter and PowerMart? view answer
Why do we need SQL overrides in Lookup transformations? view answer
What is session? view answer
What is workflow? view answer
What is worklet? view answer
Which ETL tool is more preferable Informatica or Data Stage and why? view answer
What is a mapplet? view answer
What is the use of auxiliary mapping? view answer
What is authenticator? view answer
How do we create primary key only on odd numbers? view answer
What is the difference between source qualifier transformation and application source qualifier transformation? view answer
What are the types of loading in Informatica? view answer
What is the use of control break statements? view answer
What is the difference between active transformation and passive transformation? view answer
What are the various types of transformation? view answer
What is the use of tracing levels in transformation? view answer
What is the difference between a Database and a Datawarehouse? view answer
What are the different types of OLAP TECHNOLOGY? view answer
What is Data Modeling? What are the different types of Data Modeling? view answer
What is the need of building a data warehouse? view answer
What is drill-down and drill-up? view answer
What is cube? view answer
1. What is a Data warehouse? view answer
!!! Informatica Frequently Asked Questions !!!
How will u find whether your mapping is correct or not without connecting session?
!!!Answer!!!- From Technical Expert
Through debugging option.
Answered By :
null Replied Date : Feb 2 2014
Answer :
Answered By :
null Replied Date : Oct 24 2013
Answer :
Answered By :
null Replied Date : Oct 21 2013
Answer :
Answered By :
null Replied Date : Mar 2 2014
Answer :
Answered By :
null Replied Date : Mar 22 2014
Answer :
Answered By :
null Replied Date : May 15 2014
Answer :
Answered By :
null Replied Date : Aug 26 2014
Answer :
Answered By :
null Replied Date : Sep 14 2014
Answer :
Answered By :
null Replied Date : Sep 23 2014
Answer :
Answered By :
null Replied Date : Apr 14 2015
Answer :
Answered By :
null Replied Date : Jun 10 2015
Answer :
Answered By :
null Replied Date : May 17 2016
Answer :
Ask Question and get answer from Expert.
View Answers List from Expert.
PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc
Copyright © www.techfaq360.com 2019
About US | Contact US | Privacy Policy | Terms and Conditions | Website disclaimer
| Cancellation and Refund Policy
| Shipping & Delivery Policy
Questions? Feedback? powered by Olark live chat software