#Informatica
ฝัง
- เผยแพร่เมื่อ 18 พ.ย. 2024
- #Informatica#informaticatutorial#informaticapowercenter#informaticatransformations
Parameter and Variables in informatica:
In this video we will learn
Parameters and Variable
Parameter file overview and significance in PowerCenter
Parameter file structure
Configuring the parameter files in workflow and session
Example
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌Informatica PowerCenter
github.com/nic...
📌IICS
github.com/nic...
========================================================
🌕 If you need self-paced complete Informatica ETL developer training batch recorded sessions - 35 days session(Paid) with all notes, Sample Resumes, interview questions and answers, Day wise exercise and 100 case studies questions (Paid), please write to nicitacademy@gmail.com/ or WhatsApp me @7010080468
📌 Day wise training session day 1 to 35 complete training, 35 hours
📌 All the day wise notes, exercises for practice, QA for interview
📌Resume preparation session - with 6 sample resumes
📌Roles and responsibilities session
📌Interview preparation session - Interview QA documents
📌Complex scenario session
📌Project architecture session
📌Interview questions and answers session
📌Life time access - no need to download
Please write to nicitacademy@gmail.com/ or WhatsApp me @7010080468
========================================================
🌕 Informatica 10.4 Installation with steps:
• Informatica Installati...
🔵Informatica training in TAMIL - Playlist
• Informatica Training -...
🌕 Informatica training in ENGLISH - Playlist
• Informatica Training S...
🔵Informatica Interview Preparation - TAMIL
• Informatica Interview ...
🌕 Informatica Interview Preparation - ENGLISH
• Informatica Interview ...
*******************************************************************************
learn informatica powercenter,
mapping variables & parameter,
mapping variables,
mapping parameters,
informatica videos,
informatica etl training,
informatica online course,
informatica video training,
informatica tutorial videos,
informatica online tutorial,
informatica mapping variables,
informatica mapping parameters,
informatica developer training,
Notes used in this video:
=========================
drive.google.c...
*********************************************************************
Join this channel and support my effort with your small contribution:
/ @nicitacademy
********************************************************************************
🌕Informatica Interview Preparation - Live session 2
• Informatica Interview ...
🌕Informatica Interview Preparation - Live session 1
• Informatica Interview ...
🌕Informatica interview preparation | Informatica interview questions scenario based
• Informatica interview ...
🌕How to explain Informatica ETL project in interview தமிழில் | Informatica Project Architecture
• How to explain Informa...
*********************************************************************************
informatica training in tamil,informatica in tamil,informatica tutorial in tamil,informatica interview tips in tamil,informatica tutorial for beginners in tamil,informatica interview preparation in tamil,informatica online tutorial tamil,informatica transformations with examples,informatica powercenter training,informatica tutorial,informatica,informatica tutorial for beginners,informatica - router transformation,flatfile to table load in tamil
informatica interview preparation in tamil,informatica interview preparation,informatica interview tips in tamil,informatica interview questions,informatica interview experience,informatica project explanation in tamil,informatica training in tamil,informatica interview questions scenario based,informatica training online free in tamil,informatica tutorial in tamil,informatica tamil,informatica production support issues
*Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
SIR, UR EASE OF EXPLAINATION NEXT LEVEL. Could u please make video on writing bteq scripts to load base tables in terdata as well. $$ = WE LOVE NIC IT ACADEMY 😅
Thank You. I will upload.
Awesome explanation sir
Thanks and welcome
Sir for example i want to give the query in source qualifier as
Select a.location,
(Select b.address from tab1 b
Where b.id=a id), c.city
From tab2 a inner join tab3 c on a.id=cid
In the above case do I need to drag tab1 table as well to write the subquery in source qualifier?
No need to take but output column should be dragged from source qualifier.
sir, without source transformation, can we use lookup transformation alone as a source.?
sir can you please upload part -2 video also which explains the dynamic variable declaration in informatica?
Make a video about Dynamic mapping & Work flow.
Sir, please do video on mapplets and worklets
I have already posted, please check in the playlist.
@@NICITACADEMY sir, I'm sorry. i didn't find in playlist. The video on mapplets
Wow. Good tutorial
Many many thanks
Nice. Its very useful
Thanks a lot
Can you please share time dimension creation video?
courses.nicitacademy.com/
I want to use Variable Parameter in the lookup override query in where condition to compare the port value with the passed parameter, how can i achieve this?
Please create videos on informatica BDM
Okay sure
May i know where is the academy placed in Chennai. because i see all your informatica videos
Please contact @ nicitacademy@gmail.com
Hi Sir,
I have a curl command returning a value, for now I am hardcoding it into $$val in the parameter file, how can I avoid hardcoding it?
hi, In the script itself try to manipulate the value. Please share more information to provide more insight.
@@NICITACADEMY say in one text file I have a value that needs to be stored in $$val, and $$val is in another parameter file. How do we have the value of $$val coming from another text file?
@@NICITACADEMY I hope my issue is clear.
Hi Sir, is there any way to give parameters for the different partitions?
Not that I know of
Integer Parameter is it possible?
Yes, we can do.
Please explain the scenario
How do we convert mapping param to workflow param
Hi Sir,
Couldnt find the notes. Link not working.
courses.nicitacademy.com/
Anna, can you please upload this is tamil
Sir part -2 please
I will upload soon.
@@NICITACADEMY please upload part 2 sir
Hi sir,
Can you please tell me how to perform subqueries in informatica power center.
hi, We can able to do queries in 3 different transformation, Source qualifier, Lookup override, SQL transformation. if you want to apply other logic, use transformations and complete the logic other than SQL.
part 2?
Hello sir,how to parameterise date
The same way.
Sir where is second part??
Need to upload, Keep watching my channel.
@@NICITACADEMY
Thank you for the reply sir. Kindly share 2nd part of this video as soon as poosible🙏🏻