informatica cloud tutorial for beginners
Excercise 1 : First Mapping from Source to Target - Informatica Intelligent cloud services
Ex: 2: DATA LOAD FROM FLAT FILE TO ORACLE TABLE
Ex: 3: DATA LOAD FROM FLAT FILE TO FLAT FILE INFORMATICA
Ex: 4: DATA LOAD FROM FLAT FILE TO FLAT FILE with Time Stamp in INFORMATICA
Ex: 5: DATA LOAD FROM FLAT FILE TO Dynamic relational table(oracle,sqlserver) INFORMATICA
Ex: 6: DATA LOAD FROM Fixed Width FILE TO Relational table(oracle,sqlserver) INFORMATICA
Ex: 7: DATA LOAD FROM Fixed Width FILE TO Relational table Trim First Name remove space
Ex: 8: Unicode characters-DATA LOAD FROM Flat FILE TO Relational table - UTF8 - Informatica
Ex: 9: File List DATA LOAD FROM Multiple Flat FILE TO Relational table - Informatica
Ex: 10: Excel Data Load TO Relational table - Informatica
Ex: 11: Hierarchy parser Json file Data Load To Relational table - Informatica
Ex: 12: Hierarchy parser XML file Data Load To Relational table or CSV- Informatica
Ex: 13: Relational Table (Oracle) to Hierarchy Builder XML file Data Load To XML file
Ex: 14: Relational Table (Oracle) to Snowflake cloud database
Ex: 15: Source Transformation, and its properties in
Ex: 16: Joiner Transformation in Source Transformation where sal less than 10000 and US.
Ex: 17: Filter Transformation and Unit testing and where sal less than 10000.
Ex: 18: Filter Transformation Sal greater than 5000 and dept id in 50,60,80.
Ex: 19: Filter Transformation- LEAP YEAR ONE TARGET-NON LEAP YEAR ANOTHER TARGET
EXERCISE 20: FILTER - NAME SPACE - WORKING IN DEPARTMENT 50,60,80-SAL GT 5000
Ex: 21: Expression Transformation- Salary , LEAP YEAR, PHONE NUMBER, CONCATINATION, IIF.
Ex: 22: Expression Transformation - VERTICAL MACROS - LTRIM - R TRIM
Ex: 23: Expression Transformation - HORIZONTAL MACROS - LTRIM - R TRIM - DO NOT SEND NULL
Ex: 25: Router Transformation- Load the records of INDIA and US country data in 2 tables.
Ex: 26: Name concatenation with cama for single id
Ex: 27: Rank Transformation, salary wise, department wise, top 2 salary employee.
Ex: 28: Sequence Generator Transformation and its properties.
Ex: 29: Shared Sequence from different mappings to single Target.
Ex: 30: Union Transformation From Heterogeneous Source to Single Target.
Ex: 31: Connected Lookup in .
Ex: 32: Connected lookup make inner join by using filter condition.
Ex: 33: UnConnected lookup make inner join by using filter condition.
Ex: 34 : Unconnected Lookup on multiple port
Ex: 35 : Connected/Unconnected lookup multiple match policy
Ex: 36 : Transactional Control using we created separate flat files with job id
Ex: 37: Normalizer Transformation using calculate Highest marks in subject Column wise
Ex: 38: Java Transformation splitting of rows based phone number concatenation
Ex: 39: Connected Stored Procedure in Sql Transformation
Ex: 40: Un-Connected Stored Procedure in Sql Transformation
Ex: 41: Target Transformation in - Insert, Update, Delete, Upsert operations
Ex: 42: Update Strategy SCD Type 1 in Target Transformation.
Ex: 43: Webservice transformation-Rest v2- Swagger File- API data store into table
Ex: 46: Power Center Task in Task level properties of
Ex: 44: Replication Task in Task level properties of , Synchronization Task in Task level properties of
Ex: 45: Data Transfer Task in Task level properties of
Ex: 45: Data Transfer Task in Task level properties of
informatica cloud tutorial for beginners
iics informatica full course
iics informatica tutorial
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
informatica performance tuning and optimization techniques
informatica performance tuning interview questions
informatica performance tuning scenarios
informatica performance tuning best practices
informatica performance tuning real time scenarios
partitioning in informatica
partitioning in informatica with example
hash partitioning in informatica with example
pushdown optimization in informatica with example
pushdown optimization in informatica
pushdown optimization update strategy
limitations of pushdown optimization in informatica
Informatica Interview preparation
Informatica project explanation
Informatica project explanation,architecture in telugu
how to explain informatica project architecture in interview
how to explain informatica project
informatica interview questions in telugu
how to answer informatica interviews questions
informatica insurance project architecture
informatica live projects
informatica interview questions
how to explain informatica banking project