Interested to Buy Any Domain ? << Click Here >> for more details...
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
1 7047Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
HP,
5 11240write a query to get maximum salary from the employers table without duplicates....kindly help me
CTS,
5 9878Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
TCS,
3 7115hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
HP,
3 8931What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
1 5820Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
CTS,
2 13878HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
CTS,
8 14676i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
TCS,
3 6303By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
5 8952If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
1 6555Post New Informatica Questions
How to delete duplicate row using informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is xml source qualifier transformation in informatica?
Can we override a native sql query within informatica?
What is a router transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How might you approve all mappings in the archive all the while?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How many transformations can be used in mapplets.
How can we update a record in the target table without using update strategy?
What are data-driven sessions?
How many dimensions are there in informatica?
Explain the types of lookup transformation?
What can we do to improve the performance of informatica aggregator transformation?
